UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S21IUlGau/ix9HiPVS7RyzPy1pgkDV6RwvG/1j8Y9BM='
WHERE
key_id = '34d4e37faec517677f5ce6aa1ff2002da0f6fcde1e9cdc425cc904880a12ace0'
AND (
token = 'S21IUlGau/ix9HiPVS7RyzPy1pgkDV6RwvG/1j8Y9BM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)