UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kVC7l8t166M67TQ2ekkl5cT9M5tPqHzvtohxymA3epA='
WHERE
key_id = '42cb85d70df913a4bc84e80c68939ddc3616ae3b47854d76714ef1d20ee63174'
AND (
token = 'kVC7l8t166M67TQ2ekkl5cT9M5tPqHzvtohxymA3epA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)