UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+1DDBt9RmK4V9gu3EkFvCCU/eRj2kIPGbV3/prgA9Hw='
WHERE
key_id = 'b807e13dbf0d11059a51e9a6564b491545940964670ecd8952d4349b0c019a8d'
AND (
token = '+1DDBt9RmK4V9gu3EkFvCCU/eRj2kIPGbV3/prgA9Hw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)