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