UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7RpW8GdKg45lEb8O18u0v93z8PmritwemUWuNA9+EWI='
WHERE
key_id = '42776edcdfeef8a612ea431b6914e1d824e755a6fcb00cb7e767b5405a89d9f9'
AND (
token = '7RpW8GdKg45lEb8O18u0v93z8PmritwemUWuNA9+EWI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)