UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jAyiT9XcmDGa2idaYmYqFbX69BpTEwwgM7NlCwvuIY0='
WHERE
key_id = '2a334f5e87b51575179b0c586f8579449492fd28539137fc4947cc06611c5e1a'
AND (
token = 'jAyiT9XcmDGa2idaYmYqFbX69BpTEwwgM7NlCwvuIY0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)