UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vPiBK77KXmwj2pFtkUvm2ZOUVQbIgfQTpV7/jUpZsDk='
WHERE
key_id = '188d1a954a7b97e20b7213afb9ac78ded952d972d10aa470cd3527d567b6bd86'
AND (
token = 'vPiBK77KXmwj2pFtkUvm2ZOUVQbIgfQTpV7/jUpZsDk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)