UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rzxCnK/yl2tKknN/HmE46ldEkpzGPIMyUHzj1Zoah9k='
WHERE
key_id = 'c42d29eb4b92c553c81e4714a086ae844e47b7d269b6208b5f73bc04b0c33570'
AND (
token = 'rzxCnK/yl2tKknN/HmE46ldEkpzGPIMyUHzj1Zoah9k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)