UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/dnaE7w+uu1wjWhNblbMWo7lSPgtxr/BfYRpg0wGAMg='
WHERE
key_id = '29d01f819e3a1901fb39d0277d749163b4108874b9c5a4cb342df1917658caf6'
AND (
token = '/dnaE7w+uu1wjWhNblbMWo7lSPgtxr/BfYRpg0wGAMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)