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