UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CVu2kCM9iHt72hhj7RrLMpDGmBkelOJdeYzeXD1e5IA='
WHERE
key_id = '6434d1e3c165ff4624ef0121f912ad28026c38866946ffcc068dc42706b5bb4d'
AND (
token = 'CVu2kCM9iHt72hhj7RrLMpDGmBkelOJdeYzeXD1e5IA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)