UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XB9pXqFDWgDGk3rYxVPCjRBQZpzHxHHqUJjKw5cc7YM='
WHERE
key_id = '2cf51dd1aad4678766152bbeeefe23f54c4adc15e0c2e8fff1dc7a1e0b8b1cbc'
AND (
token = 'XB9pXqFDWgDGk3rYxVPCjRBQZpzHxHHqUJjKw5cc7YM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)