UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/qmCI3BN16gfire+X6+aaWtskeyOuw/DpEISVT84Z64='
WHERE
key_id = 'bfdc4f8c6c963ef59c2604fc73858441915b9e82e9b8eac583ffea4c7c4b6475'
AND (
token = '/qmCI3BN16gfire+X6+aaWtskeyOuw/DpEISVT84Z64='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)