UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HvrBz47DREbEusNIzs8oZdhDffL2JSDN6v9n4kM7R0M='
WHERE
key_id = '8295d37023060a56900de4c8e112148c32e44f42ef1e9a5cf2e5aab7c61be023'
AND (
token = 'HvrBz47DREbEusNIzs8oZdhDffL2JSDN6v9n4kM7R0M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)