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