UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ackWPkSgS6YzfcuS+HkbVbZERKppjcdWRHghB6vi5aw='
WHERE
key_id = '8ba3c4be8eb6bd07bc9af45c4ca55c7eef7ce69cb7f23f819ee94a9d19f9914b'
AND (
token = 'ackWPkSgS6YzfcuS+HkbVbZERKppjcdWRHghB6vi5aw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)