UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HC7FzHorCIic8XxXhsEH8e2uJn6btSa2R9oE7ypQpuU='
WHERE
key_id = '24fb65c566fe25d53573115ed3ee710734e730e4364e835db044da173e0139ae'
AND (
token = 'HC7FzHorCIic8XxXhsEH8e2uJn6btSa2R9oE7ypQpuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)