UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0xIVGX16S/8pm+ZRxnEnIOpTthC3nFcYMk2zYSNfkTA='
WHERE
key_id = '27861641798904609ef1ef1e5288ac5bd1c4988c10a49ba66b9a33d7f6e621c9'
AND (
token = '0xIVGX16S/8pm+ZRxnEnIOpTthC3nFcYMk2zYSNfkTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)