UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+QNXpQi8OvwiWuiwgPBpsWGy112krPkvbqU84qd/BFU='
WHERE
key_id = 'f3db93017d664f6231b22158bb0def50e6b59e320829283b0f2279d58278bcd5'
AND (
token = '+QNXpQi8OvwiWuiwgPBpsWGy112krPkvbqU84qd/BFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)