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