UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dfTY3z37KpxAlH3YMaG0RxcWwTMyH9gtRCO9sMYpI/Y='
WHERE
key_id = 'dc378df798b08abcc653a24d5439d00d9bf9d9eb83cccb6f1f66bb8a4af0665c'
AND (
token = 'dfTY3z37KpxAlH3YMaG0RxcWwTMyH9gtRCO9sMYpI/Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)