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