UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9wxfEUI7fl5BB5xYQ632+/8IouRF7yCbrWyyLJagUX0='
WHERE
key_id = 'e8d292385db89289c5c94f73f467646f138609eb67075440bd234b4d04d0ff6f'
AND (
token = '9wxfEUI7fl5BB5xYQ632+/8IouRF7yCbrWyyLJagUX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)