UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2J3mGilIzKvaX1kCbvVeJtWgvsecIKDAHKTZX7u+8q8='
WHERE
key_id = '943ebb4d1fef84b4e9eab942349d47afb391b1942e3a4ca082ddba8ec57cbc78'
AND (
token = '2J3mGilIzKvaX1kCbvVeJtWgvsecIKDAHKTZX7u+8q8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)