UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W8f54c9Y7M8Ri0twKyHWoquTVjoany29GL60QkUH0Hk='
WHERE
key_id = 'b06aa9553cf87b01c71858ae36d89c3caff9a0a5a498c2ac0b51612759d20383'
AND (
token = 'W8f54c9Y7M8Ri0twKyHWoquTVjoany29GL60QkUH0Hk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)