UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qNz5uNz3r0SDCpKMYvm7oPGavAhZTS0zXbU8uD4Mr98='
WHERE
key_id = 'e58617624be342384a10a85523a85700e8625c1f45ce0ec28957d7a9cf24123a'
AND (
token = 'qNz5uNz3r0SDCpKMYvm7oPGavAhZTS0zXbU8uD4Mr98='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)