UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q1LpBeE1TPj3zNBcarxtSvethfUE5GqxU6X3eef+uM4='
WHERE
key_id = 'b9cfe471ed33cc1de7465c21fb71077856291e79c8ed9c77c9989467f56de854'
AND (
token = 'q1LpBeE1TPj3zNBcarxtSvethfUE5GqxU6X3eef+uM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)