UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CflMl5aUA6N3zl4ucEOqTdiTaORzBVcttODvoyEjyUk='
WHERE
key_id = '5ccb9ebdd493012e9579d828c22802742904028e0e7ddb681eebd2ae65eb16a2'
AND (
token = 'CflMl5aUA6N3zl4ucEOqTdiTaORzBVcttODvoyEjyUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)