UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WuLmfizJQ5P1cjC0towgiqNl7dVj2y83A8s/8jGhcf0='
WHERE
key_id = 'c523a271b4933e8c774458ac57ab2cd9419806795d5cdc191f53b99f0ed3b08b'
AND (
token = 'WuLmfizJQ5P1cjC0towgiqNl7dVj2y83A8s/8jGhcf0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)