UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7CHlE4KFuIZIwDBkBkh+jWvXEKyjF7il/3n0n7Kg2pA='
WHERE
key_id = '15e3dd9356e0bd73266c734f6439f51c44145b108553616a929c63d578200a5e'
AND (
token = '7CHlE4KFuIZIwDBkBkh+jWvXEKyjF7il/3n0n7Kg2pA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)