UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0o9kxLTwH/XgwNNF0MHBsrOuaUP2B0oJsb5/kY9kPys='
WHERE
key_id = '307dfd271cfb95aca536be0acb5ff91eb72eb8e0c8d3fbc9f1665bce07dc0c0d'
AND (
token = '0o9kxLTwH/XgwNNF0MHBsrOuaUP2B0oJsb5/kY9kPys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)