UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r7YtQ3I4Cc9T2P/frhD0vjvPt1NrBYtEvca8TQzIbOM='
WHERE
key_id = 'a794290ded220976ef91bbc482f6d1021e54675f34bef2fc8b430f8736703198'
AND (
token = 'r7YtQ3I4Cc9T2P/frhD0vjvPt1NrBYtEvca8TQzIbOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)