UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J6lnC0fy7bDzIopHCCwMD5gi/XAvSpFuD7sn6oOjsIg='
WHERE
key_id = '4f83f09b2d7dd67439c31cf55869244307c52726b578d4f99c451a152c29b596'
AND (
token = 'J6lnC0fy7bDzIopHCCwMD5gi/XAvSpFuD7sn6oOjsIg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)