UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9np8I77X/2ydniLbowjWHkTl9ZW520u72mT1y0lt390='
WHERE
key_id = 'c3ab1883dd084b26cd3e40ca0a01c37a917cb4b146825e516e85c0bad86bca0e'
AND (
token = '9np8I77X/2ydniLbowjWHkTl9ZW520u72mT1y0lt390='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)