UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tSanjihDIhBcFZVqip4Kr9t7GUAUbZp7eZ18O0nRF3g='
WHERE
key_id = '9d78790a9cba3546984fea15c9b0c75ebb841a9de625111e5b55e6fd282e4405'
AND (
token = 'tSanjihDIhBcFZVqip4Kr9t7GUAUbZp7eZ18O0nRF3g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)