UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pbuNFLpRTncYSK6m8oW10T7Ld3mGJJRJRNKcb+xVrOQ='
WHERE
key_id = '1f7f46cb29fc8eee860335e3b1bdb0e34d00bf389003805be72f1ec7fc14d297'
AND (
token = 'pbuNFLpRTncYSK6m8oW10T7Ld3mGJJRJRNKcb+xVrOQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)