UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O74cip6rXXg5VIe8ElMq52AQAVcFRaYFKCrAG7NTvUg='
WHERE
key_id = '48eef989e2537c8febd736c9123808d974719fdd373cf039d7fc7fe0ec77c8a4'
AND (
token = 'O74cip6rXXg5VIe8ElMq52AQAVcFRaYFKCrAG7NTvUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)