UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zCN7Vi6/fmBhUMFrY9gTAZaTrbSmIjrKWybP4esPs0g='
WHERE
key_id = '9992415ceaef7cd028b7645e82531edb9f8e46f247b0d6372146a1b3a42caf70'
AND (
token = 'zCN7Vi6/fmBhUMFrY9gTAZaTrbSmIjrKWybP4esPs0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)