UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BC5vcyQ5o7H7naWUb2NsTfYuFL31DnUxu0yj8XhpLg8='
WHERE
key_id = 'dd29b0e7502cabb8adbb0d5f591536f8c8eb4197bce032aa7ef3d0e90d31e849'
AND (
token = 'BC5vcyQ5o7H7naWUb2NsTfYuFL31DnUxu0yj8XhpLg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)