UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hlns/pAAo0/i2/ucmZStgtJ73pg8J0p6XLjZGS88JuI='
WHERE
key_id = '0f4c65c2d4339329e58174e281ff7b73066dfecc3e3eb743439be0136676ae6c'
AND (
token = 'hlns/pAAo0/i2/ucmZStgtJ73pg8J0p6XLjZGS88JuI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)