UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6KgLxnrhZj87jlG9liAEt+Wx6z4hhN1AHu+8FspTCFc='
WHERE
key_id = 'e6cb58b9d23aece0e7c43da8809444001c50457df47b3bb07b21f84693a80e33'
AND (
token = '6KgLxnrhZj87jlG9liAEt+Wx6z4hhN1AHu+8FspTCFc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)